07. 解决方案：POSITION、STRPOS 和 SUBSTR

POSITION、STRPOS 和 SUBSTR 解决方案

1. SELECT LEFT(primary_poc, STRPOS(primary_poc, ' ') -1 ) first_name, 
      RIGHT(primary_poc, LENGTH(primary_poc) - STRPOS(primary_poc, ' ')) last_name
   FROM accounts;

2.

SELECT LEFT(name, STRPOS(name, ' ') -1 ) first_name, 
          RIGHT(name, LENGTH(name) - STRPOS(name, ' ')) last_name
FROM sales_reps;